MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

11 rows where Artist Nationality = 59

View and edit SQL

Suggested facets: Is Public Domain, Department, Object Name, Title, Artist Role, Artist Prefix, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, Classification

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
11697 42.95.31 0 1 12714 American Paintings and Sculpture 2 Watercolor 198 The Chief of the Little Osages           Artist|Artist 13 After Pavel Petrovich Svinin|Charles Balthazar Julien Févret de Saint-Mémin 1787/88–1839|1770–1852   Svinin, Pavel Petrovtch|de Saint-Mémin, Charles Balthazar Julien Févret 1822 Russian|French 59 1787 |1770 1839 |1852 1811–ca. 1813 1811 1816 Watercolor and black chalk on off-white wove paper 1914 8 1/4 x 6 1/4 in. (21 x 15.9 cm) Rogers Fund, 1942                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
11723 42.95.30 0 1 12740 American Paintings and Sculpture 2 Watercolor 198 An Osage Warrior           Artist|Artist 13 After Pavel Petrovich Svinin|Charles Balthazar Julien Févret de Saint-Mémin 1787/88–1839|1770–1852   Svinin, Pavel Petrovtch|de Saint-Mémin, Charles Balthazar Julien Févret 1822 Russian|French 59 1787 |1770 1839 |1852 1811–ca. 1813 1811 1816 Watercolor, black chalk, and gum arabic on white wove paper 1929 8 1/4 x 6 3/16 in. (21 x 15.7 cm) Rogers Fund, 1942                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
81303 1980.176 0 0 109788 Costume Institute 8 Fancy dress costume 5897 Fancy dress costume American 1         Designer|Designer 85 Textile designed by Léon Bakst|Raoul Dufy Russian, Grodno 1866–1924 Paris|French, Le Havre 1877–1953 Forcalquier   Bakst, Léon|Dufy, Raoul 6569 Russian|French 59 1866 |1877 1924 |1953 1919 1919 1919 silk, glass, plastic 15293   Gift of Flora M. Irving, 1980                           Metropolitan Museum of Art, New York, NY 1
292599 1970.721.1 0 0 421932 Drawings and Prints 11 Print 731 Set design for Shakespeare's Othello, Act 1         Maquettes de Théâtre 2032 Artist|Publisher|Subject 3110   Alexandra Exter|Editions des Quatre Chemins|William Shakespeare Russian, Belostok, Russia 1882–1949 Paris, France|French|British, Stratford-upon-Avon 1564–1616 Stratford-upon-Avon   Exter, Alexandra|Quatre Chemins Editions des|Shakespeare, William 41883 Russian|French 59 1882 |1564 1949 |1616 1930 1930 1930 Pochoir; from an edition of 160 43913 Sheet: 13 × 19 15/16 in. (33 × 50.6 cm) Image: 9 1/16 × 11 5/8 in. (23 × 29.5 cm) Gift of Nikita D. Lobanov, 1970   Paris 27                   Prints 13   Metropolitan Museum of Art, New York, NY 1
292612 1970.721.2 0 0 421945 Drawings and Prints 11 Print 731 Set design         Maquettes de Théâtre 2032 Artist|Publisher 710   Alexandra Exter|Editions des Quatre Chemins Russian, Belostok, Russia 1882–1949 Paris, France|French   Exter, Alexandra|Quatre Chemins Editions des 41886 Russian|French 59 1882 1949 1930 1930 1930 Pochoir 30782 Sheet: 12 15/16 × 19 7/8 in. (32.9 × 50.5 cm) Image: 9 1/16 × 11 1/16 in. (23 × 28.1 cm) Gift of Nikita D. Lobanov, 1970   Paris 27                   Prints 13   Metropolitan Museum of Art, New York, NY 1
292615 1970.721.3 0 0 421948 Drawings and Prints 11 Print 731 Set design for Goethe's "Faust"         Maquettes de Théâtre 2032 Artist|Publisher 710   Alexandra Exter|Editions des Quatre Chemins Russian, Belostok, Russia 1882–1949 Paris, France|French   Exter, Alexandra|Quatre Chemins Editions des 41886 Russian|French 59 1882 1949 1930 1930 1930 Pochoir 30782 Sheet: 13 1/16 × 20 in. (33.2 × 50.8 cm) Image: 9 1/2 × 12 11/16 in. (24.2 × 32.2 cm) Gift of Nikita D. Lobanov, 1970   Paris 27                   Prints 13   Metropolitan Museum of Art, New York, NY 1
292618 1970.721.4 0 0 421951 Drawings and Prints 11 Print 731 Circus         Maquettes de Théâtre 2032 Artist|Publisher 710   Alexandra Exter|Editions des Quatre Chemins Russian, Belostok, Russia 1882–1949 Paris, France|French   Exter, Alexandra|Quatre Chemins Editions des 41886 Russian|French 59 1882 1949 1930 1930 1930 Pochoir 30782 Sheet: 13 × 19 13/16 in. (33 × 50.3 cm) Image: 8 5/8 × 12 1/16 in. (21.9 × 30.6 cm) Gift of Nikita D. Lobanov, 1970   Paris 27                   Prints 13   Metropolitan Museum of Art, New York, NY 1
292654 1970.721.5 0 0 421988 Drawings and Prints 11 Print 731 Circus         Maquettes de Théâtre 2032 Artist|Publisher 710   Alexandra Exter|Editions des Quatre Chemins Russian, Belostok, Russia 1882–1949 Paris, France|French   Exter, Alexandra|Quatre Chemins Editions des 41886 Russian|French 59 1882 1949 1930 1930 1930 Pochoir 30782 Sheet: 12 15/16 × 19 3/4 in. (32.8 × 50.2 cm) Image: 9 1/8 × 11 3/4 in. (23.2 × 29.8 cm) Gift of Nikita D. Lobanov, 1970   Paris 27                   Prints 13   Metropolitan Museum of Art, New York, NY 1
292655 1970.721.6 0 0 421989 Drawings and Prints 11 Print 731 Set design for an operetta         Maquettes de Théâtre 2032 Artist|Publisher 710   Alexandra Exter|Editions des Quatre Chemins Russian, Belostok, Russia 1882–1949 Paris, France|French   Exter, Alexandra|Quatre Chemins Editions des 41886 Russian|French 59 1882 1949 1930 1930 1930 Pochoir 30782 Sheet: 12 15/16 × 19 3/4 in. (32.8 × 50.2 cm) Image: 9 5/8 × 12 3/8 in. (24.5 × 31.5 cm) Gift of Nikita D. Lobanov, 1970   Paris 27                   Prints 13   Metropolitan Museum of Art, New York, NY 1
292657 1970.721.7 0 0 421991 Drawings and Prints 11 Print 731 Set design for an operetta         Maquettes de Théâtre 2032 Artist|Publisher 710   Alexandra Exter|Editions des Quatre Chemins Russian, Belostok, Russia 1882–1949 Paris, France|French   Exter, Alexandra|Quatre Chemins Editions des 41886 Russian|French 59 1882 1949 1930 1930 1930 Pochoir 30782 Sheet: 13 1/16 × 19 13/16 in. (33.1 × 50.4 cm) Image: 8 3/16 × 12 3/16 in. (20.8 × 31 cm) Gift of Nikita D. Lobanov, 1970   Paris 27                   Prints 13   Metropolitan Museum of Art, New York, NY 1
292662 1970.721.8 0 0 421996 Drawings and Prints 11 Print 731 Set design for C. W. Gluck's "Don Juan"         Maquettes de Théâtre 2032 Artist|Publisher 710   Alexandra Exter|Editions des Quatre Chemins Russian, Belostok, Russia 1882–1949 Paris, France|French   Exter, Alexandra|Quatre Chemins Editions des 41886 Russian|French 59 1882 1949 1930 1930 1930 Pochoir 30782 Sheet: 13 × 19 13/16 in. (33 × 50.3 cm) Image: 9 3/8 × 11 1/2 in. (23.8 × 29.2 cm) Gift of Nikita D. Lobanov, 1970   Paris 27                   Prints 13   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 135.82ms · Data license: CC0 · Data source: metmuseum/openaccess